MySQL

Adding MySQL data source

From the left navigation panel, click Lakehouse and then click Data Sources.
From the upper right corner of the page, click the + New Database button to start the process of adding a new database.
In the New Data Source page, click the MYSQL icon.
Specify the following details to add Microsoft SQL. Once you have connected a data source, the system immediately fetches its schema. After this schema retrieval process is complete you can browse and interact with the tables and data.

Field	Description
Connection name	Enter a unique name for the connection.
Database	Specify the name of the existing database that you want to connect.
Host name	Specify the hostname or IP address of the server wherein the database is located.
Port name	Enter the port number used by the database server.
Schema	Specify the schema name for your MySQL connection. If left blank, the default schema will be used (“public” for Postgres and “dbo” for Microsoft SQL).
Properties	Specify additional settings by entering key/value pairs. Each pair represents a unique property and its value.
Case Sensitive	Specify whether your MySQL Server data source has case-sensitive table names. This option allows for seamless integration with databases that use Camel Case or other naming conventions.